﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Texfina.Core.Data;
using Texfina.Entity.Co;
namespace Texfina.DOQry.Co
{
    public class DProveedor
    {
        public static DataSet ProveedorFill(EProveedor prov )
        {
            DBAccess db = new DBAccess();

            db.AddParameter("@pvchcriterio",prov.Ds_raznombre);

            db.AddParameter("@id_clipro", prov.Id_clipro);

            db.AddParameter("@nu_dociden", prov.Nu_dociden);

            return db.ExecuteDataSet("MG_Tercero_qry01");
        }
        
        public static IDataReader Proveedor_qry02()
        {
            DBAccess db = new DBAccess();
            return db.ExecuteReader("MG_Tercero_qry02");
        }
    }
}
